EXCEL

 

1.          BUILDING A SIMPLE WORKSHEET

             Entering Text, Entering Values, Entering Dates and Times, Moving Around, Selecting Ranges, Using Menu, Using Tool Bar, Using Shortcut Menus, Changing entries, Copying entries, Moving Entries, Inserting and Deleting cells

 

2.          FORMATTING BASICS

             Changing Character Style, Changing Alignment, Changing Column Width

 

3.          WORKING WITH MULTIPLE WORKSHEET

             Copying entries between work books, Moving sheets between work books, Deleting sheets, Quitting Excel

 

4.          OPENING EXISTING WORKBOOKS

             Simple calculations, Doing Arithmetic, Totaling column of values, Naming cells and Ranges

 

5.          FORMATTING TEXT

             Displaying dollars and cents, Formatting decimal places, Formatting dates, Copying style and formats

 

6.          FORMULAS THAT MAKE DECISIONS

             Using the IF function, Using the nested IF function, Copying formulas                           

7.          Checking Spelling, Printing Worksheets, Preview Worksheets, Setting up the pages,

 

8.          Sorting data, Keeping Leading in View, Finding records, Adding and deleting Records, Filtering Records

 

9.          Plotting charts, Sizing and moving charts, Updating charts, Changing the chart type, Using chart auto format

            

10.       Creating Macros, Recording Macros, Running Macros